USE [mundial]
GO
/****** Object:  StoredProcedure [dbo].[sp_GetUsuarioContrasenia]    Script Date: 05/11/2014 10:16:27 ******/

/**
 * 
 * @author Gab
 */

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_GetUsuarioContrasenia_2]
@inNombreUsuario VARCHAR(100),
@inContrasenia VARCHAR(100)
AS

SELECT TU.* 
    FROM usuario TU 
        WHERE (TU.nickName = @inNombreUsuario AND TU.contrasena = @inContrasenia) 
			OR(TU.correoElectronico = @inNombreUsuario AND TU.contrasena = @inContrasenia)





